package com.wxlgroup.springboot.dao;
import com.wxlgroup.springboot.entity.DElink;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import java.util.List;

@Mapper
public interface EquipmentDao {


    //查询所有的设备
    public List<DElink> queryAllEquipments(@Param("equipmentName") String equipmentName,@Param("departmentName") String departmentName);

    //到处设备
    public List<DElink> export();

    //修改设备的相关信息
    public int updateEquipment(@Param("delink") DElink dElink,@Param("departmentId") int departmentId);

    //删除一个设备记录
    public int deleteEquipmentById(int id);

    //增加一个设备信息
    public int insertEquipment(@Param("delink") DElink dElink);

    //根据设备的名称找设备记录
    public List<DElink> queryEquipmentIdByName(String equipmentName);

    //往设备表里新增一个设备名称
    public int inertEquipmentIntoEquipment(String name);


    //查询设备id
    public int selectEquipmentIdByName(String name);

}
